
'''
生成质谱数据表
'''

import pandas as pd
pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)

DATA=dict()
dataDf=pd.read_excel("data.xlsx")
for k,v in dataDf.to_dict().items():
    DATA[k]=v[0]

DATA['product_mz']=list(map(lambda x:float(x.strip("'"))
                            ,DATA['product_mz'].split(";")))
DATA['product_intensity']=list(map(lambda x:float(x.strip("'"))
                            ,DATA['product_intensity'].split(";")))
print(pd.DataFrame(DATA))
